SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483411 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483411 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101434,6474,671017,612036,854200,986584,86316,607748,240096,441074,920957,148642,26908,475495,314506,622527,822827,273449,568032,972784,653094,26166,416628,284089,142288,749688,211743,776913,133458,45439,469971,498186,156260,860368,521705,407033,372203,889650,507120,286847,177398,231527,867015,448487,811103,948316,560252,306075,324800,200764,623764,511887,190788,647550,698359,807747,658954,73993,492260,760044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]