SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420380 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420380 [ RunTime:0.001391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120272,745849,339423,335365,86681,953973,309123,804269,778396,817394,721929,964873,1036141,727346,931326,319687,531065,307656,1040634,641377,709555,316204,339657,118804,813671,990209,871973,309047,447774,890552,698186,541307,974650,592801,423201,891047,469753,707194,496189,884489,27857,85898,310337,42680,413468,14632,274189,128340,475288,887252,1021571,81049,188129,733281,89249,609236,1004485,97372,660353,205838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]