SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285422 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285422 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689056,474169,789856,545085,614023,178511,177115,574963,1003960,520492,837140,15311,447162,603073,246325,346633,1035219,1009090,1026537,730630,964688,596889,635120,81572,647932,869799,863325,955375,699111,547438,889435,428815,70365,415094,797733,515519,91416,525356,129714,37421,670336,515066,485406,610115,254344,852681,403546,229005,925884,537122,321589,284120,449284,779609,334287,607141,1008750,922489,648693,294395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]