SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502603 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502603 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039577,578191,343043,959112,979932,423964,915840,237333,726147,949545,758937,474165,451162,454998,364845,181403,694982,1027560,475170,896593,921742,848567,940842,23408,849742,467826,16156,859100,471350,517802,386849,190654,216857,793268,604045,1006444,860274,532094,484716,374814,1044702,183236,400693,342332,376816,498058,636776,794362,663421,312046,442176,346869,1780,297809,79900,24059,269547,202918,52342,58892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]