SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171015 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171015 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495108,58511,386223,687823,940834,52875,365067,1015111,920644,178995,264666,1048789,905471,930716,972351,633675,521042,645679,761814,56985,244799,285712,734122,780296,557597,707162,521652,974746,853475,31310,431971,770686,363530,825290,981382,404482,844209,124737,930978,147286,688787,845315,79827,167344,434869,594265,794043,347959,220277,562743,125212,139024,796199,824837,605359,904141,69579,713255,1046038,810307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]