SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 179343 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 179343 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415257,267175,214703,608138,388140,339285,994244,465680,191285,1011105,60645,751624,967453,976447,608905,123660,266853,495039,122528,437382,359183,341388,1038523,72678,317699,724595,701860,545330,242683,602568,613052,283201,585365,46100,175042,608675,442656,186644,390581,38894,203589,537740,1040926,543221,558594,562809,969958,217202,509571,921096,392754,351290,958485,57451,531937,964909,871029,605050,618852,453824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 179343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 179343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]