SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503974 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503974 [ RunTime:0.003104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125628,478607,205008,382274,975690,451359,566576,450155,1013426,851128,794346,164680,991411,692247,600916,178921,39343,313587,242998,203849,931486,301765,381335,592352,904148,720456,820310,982412,180777,660513,308561,155448,733957,196390,535378,578302,214931,127885,262125,43799,469120,157282,418111,1018989,878142,328823,671550,808991,368498,313578,316667,667614,837494,715244,515877,475295,943813,259540,771112,553116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]