SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112940 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112940 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800811,17876,182509,341977,449570,20520,104938,266324,816973,307443,774182,792888,908959,934357,985206,24620,623368,673813,796354,1012335,2694,49299,676776,611503,373260,847306,830457,759988,421852,1011020,727273,372713,717925,951335,931413,777846,129216,153988,784484,499784,174704,579324,656591,86724,314726,1009898,244701,988867,425012,532270,944975,922451,787191,334063,736841,887472,849558,305547,1021960,523438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]