SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 277111 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 277111 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727171,447758,1009615,914267,121431,860450,802272,243853,127539,376372,581598,408756,523673,35431,513857,318046,1048580,461234,1031251,692892,179482,548019,410174,538415,10017,920118,42456,391040,653403,622195,1047953,66012,781890,117439,683861,403812,497964,732220,485269,320089,534150,444381,337265,477181,347155,876844,155542,102662,833891,839252,328927,900585,25603,327608,369791,89190,841410,229823,60980,272637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 277111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 277111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]