SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554040 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554040 [ RunTime:0.003279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601703,210744,609186,587700,159219,600395,437230,471558,93946,767202,906950,65252,446241,64904,717941,44836,997488,420038,157955,817835,256527,741946,989089,685046,768099,784098,954838,340284,534978,730995,899118,532138,773384,56522,659234,623543,333215,558746,839319,66774,168340,753527,42295,199006,1004799,942820,581980,41563,667296,526444,876954,526868,676988,342676,220279,478543,692309,46489,210824,377564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]