SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3428 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3428 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004048,110442,770459,231590,957013,787415,246843,693588,727438,261770,151830,151289,156985,905026,875522,234723,9682,330227,488794,1004335,293449,960847,22304,216298,922237,310354,1010454,950711,88807,1020567,826325,461027,341790,75160,929645,1046362,1044216,405544,658646,456871,782751,1039932,788488,394120,29835,831381,513832,114200,959708,552179,60788,543369,85289,417292,256399,652967,435094,821192,524674,943175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]