SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525648 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525648 [ RunTime:0.003054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184446,870645,144171,756896,205677,1044105,207182,461613,575650,928095,981494,782416,143340,843451,942120,749022,159717,110850,1009795,674359,911634,515282,507325,699070,1035219,160101,540049,1046394,770448,289550,101387,861384,951940,671164,62355,859020,19754,557122,1048458,546490,339631,742505,152914,606990,752712,365550,374478,81810,107181,171887,92921,349500,996503,7013,114858,232295,1014748,629622,447645,729138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]