SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292641 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292641 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027763,231836,270978,924827,163637,588085,875631,131563,519107,100183,893534,297477,583368,1011682,436272,667596,194086,651708,81309,150558,624866,264366,910100,997292,61242,120650,848975,24451,239685,623243,472609,115036,153280,662425,122572,697546,358219,149714,546679,436807,786785,32898,874966,1000560,700019,183530,988789,63128,958579,668935,750883,1009767,26840,4837,855846,786567,543026,2717,420657,599954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]