SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505101 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505101 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785429,580668,941822,399087,634939,461726,721283,620686,936194,517512,774153,199782,36866,546957,14982,877276,324364,207763,361693,115785,697001,890639,875123,604481,355738,901151,111685,616694,685116,949392,464071,46014,569892,807807,273539,999845,846303,175502,877871,700463,496040,552654,828420,681932,952836,732207,394071,618800,247359,892492,852175,180593,859899,643167,154901,137710,58237,185395,346543,263859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002214s ]