SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195120 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195120 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767151,426395,280336,294484,995517,787302,178824,59027,14129,694025,1035743,369797,778375,355337,142179,550712,975114,1030203,503651,1038911,4208,300661,322579,529535,202297,311680,193887,661359,291159,952324,158712,437188,209474,143171,315273,757372,160912,1018235,218111,203062,42336,597955,943932,954879,670171,146295,495348,678395,820277,69962,546101,651533,39718,519322,22066,783726,32759,8331,914725,216825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]