SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416470 LIMIT 1 [ RunTime:0.000701s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416470 [ RunTime:0.004356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405739,609788,543736,64824,914910,590078,909491,118687,504027,134123,222600,604610,336610,915265,430262,514621,894357,706235,357700,183417,313526,780949,914704,309178,655408,609704,98371,991695,490596,989275,605744,271977,626549,128393,445417,914622,880288,434725,22603,380902,89763,769554,88538,444877,181622,998687,796562,550949,518306,668664,618645,976851,251416,732160,624582,35014,183640,528454,113469,127439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]