SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43303 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43303 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267622,272841,617270,943343,713805,624408,120450,128303,850285,537632,493070,847271,666375,1006691,185797,328419,739060,1000779,959331,376729,261165,301863,441710,503926,892271,213529,859992,592264,536847,803106,3654,870986,799290,720989,134358,612816,171196,1041916,470584,363153,524542,491687,686496,747078,862618,806990,5288,365652,393756,320585,210874,709454,330613,393257,595461,903825,602651,487909,570717,413343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]