SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510341 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510341 [ RunTime:0.002877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037934,631364,224296,43741,894549,507255,251891,964473,640877,632728,927986,546786,49577,251841,654172,887666,659051,363610,534243,858129,252060,744725,205514,756313,62053,607571,787962,646122,480956,758218,83405,614618,345966,705064,61190,393865,367417,904095,208151,828907,163896,554607,552849,1031678,222302,426015,378810,149785,400386,627665,57741,768453,661916,1047443,702447,354159,757228,426053,154438,156154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]