SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 188104 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 188104 [ RunTime:0.002859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570281,812735,334872,1029157,847984,532146,713174,927809,424853,223780,134827,738723,195218,1011512,859437,477818,623645,1045260,379520,519334,614407,708954,993421,643928,648251,420064,899162,932678,130943,446751,245107,127358,742636,35328,279997,615544,181740,1017376,77474,711900,198858,827029,472617,393347,519052,10819,640092,134891,744679,543229,687911,373724,419336,908378,772523,95231,599008,413080,967551,827810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 188104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 188104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005923s ]