SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450199 LIMIT 1 [ RunTime:0.000655s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450199 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816634,472100,348012,848558,963444,993244,819574,90379,480451,673723,78664,411921,614519,403388,990318,990599,117321,443555,467397,18247,5016,210172,808125,888589,268049,326206,259504,640789,460608,743454,117856,766796,552547,449911,927699,803980,449696,244922,381531,943580,684004,817767,538125,455011,529282,593312,448247,774492,908158,85498,791643,53480,453372,1024205,709332,537873,374322,31751,708179,205419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]