SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672591 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672591 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48847,755536,991480,420533,192990,605285,1038708,484467,383563,104164,14267,587140,543742,334007,648677,361188,421246,63607,984729,490291,779111,268672,712473,97377,549166,394356,583759,160258,364139,319488,948507,430673,97108,724756,427871,58892,417891,414661,950121,308181,438338,69453,180529,1005204,525954,60749,338551,309368,640004,825406,747921,1003149,561062,648685,1039719,314108,321560,540755,636422,175904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]