SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971612 LIMIT 1 [ RunTime:0.001962s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971612 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74867,186853,902361,562337,469839,976396,311915,421924,245095,761835,549752,580846,495088,466675,984507,922194,1039655,1005043,946702,958860,812140,524516,4067,632289,855569,431781,788046,767484,480118,36556,303025,499272,858377,285136,962110,1044890,899493,968907,707191,291090,769106,241169,850963,272723,337046,311642,735782,400991,890417,806804,242157,885833,403560,661868,781169,569951,81767,233616,268944,593444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]