SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042178 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042178 [ RunTime:0.005015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471575,278752,57755,15887,397888,146506,346179,535469,387930,15073,131860,83734,557512,440437,752553,787322,529568,205153,495277,379863,395374,934677,586883,887989,819570,649086,2808,375296,829751,174040,997278,981498,563641,715745,988628,434726,845156,891964,1002319,606098,650836,577244,937770,504589,1000108,899409,638921,478778,721045,547562,715983,475952,729618,830822,386930,964551,120023,845858,992254,108674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]