SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45650 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45650 [ RunTime:0.002352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614644,454486,938243,310843,986938,172584,679378,68195,541878,192782,923967,728875,625569,413580,13032,438482,449155,701199,81904,131819,321117,619058,788103,618244,165147,694954,132316,128867,704745,983088,409254,507930,988140,449573,262456,250982,887261,152843,835189,240477,606819,902842,689620,662388,252127,952257,622079,41072,384219,250209,245059,720488,735473,64008,507134,620652,617183,777158,423090,371534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]