SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454407 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454407 [ RunTime:0.002546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207793,557788,607171,187667,636320,242091,644365,778670,201194,845356,625246,614046,1027588,167761,907099,417095,414543,364020,430062,414067,291665,718427,266209,904606,233712,932676,224376,638278,102609,155421,508517,309205,224579,297161,762509,55588,955086,400830,181746,470767,713485,78698,926931,434354,738310,794599,352603,435076,901425,742069,514920,418897,376562,704851,477635,235034,14394,667018,912725,237830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]