SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528593 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528593 [ RunTime:0.003813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191597,3036,867548,653911,566665,847044,677145,896495,33172,732877,171870,259351,426097,910111,829196,124608,476356,969041,330923,45326,1031448,901505,623067,933576,863478,892151,34344,672250,168558,680790,341102,310133,865798,828316,293555,354205,424652,335660,950461,377657,213074,976193,420121,754129,138903,247835,167825,987698,405652,869992,1039260,315651,616740,289812,908633,23571,130643,894167,52720,837946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]