SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404831 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404831 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518892,781185,979196,212003,157316,779885,802174,364523,367034,1010598,385278,522696,617598,18527,313648,412547,438280,96866,38588,759007,865215,353074,470601,731286,38299,112325,321576,898968,273835,441504,615606,197757,753376,503536,235789,453971,942878,290656,272195,870290,540957,138222,154822,108083,938821,452341,312154,519644,265636,95572,857459,160970,251666,656651,628531,1007033,299337,641750,193602,647130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]