SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422473 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422473 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414420,348064,829291,482983,121728,1038404,362041,659680,543500,825158,981252,242601,719350,892009,765884,705666,616050,496361,402318,174789,464012,521361,1038833,685124,472684,600946,519702,54922,838772,918886,282335,175421,593308,743529,745482,372406,986354,849468,746093,731587,866918,85075,155691,717180,990000,478636,822327,613507,93200,937742,213300,665370,115761,440026,305963,146236,471013,540601,967143,548794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]