SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429438 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429438 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619092,1164,404878,327281,113092,434727,632984,605325,93821,41894,128032,476617,279280,738870,135190,88564,968776,324695,763441,808149,701949,352056,58570,491395,813006,986038,10237,752186,491279,841037,684438,762247,943752,109507,699802,15444,838814,633364,1037465,81313,477693,954492,972032,832985,335715,176065,385350,295691,856532,440314,861288,819516,599364,196908,287690,35953,957690,886443,464248,240661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]