SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380512 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380512 [ RunTime:0.002979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280097,954584,874814,588544,1016161,911078,114454,385312,106611,260313,679236,938054,917733,692009,127891,731597,692862,95317,851236,381580,581698,538704,813110,941325,707150,708046,1040746,214455,1021848,1044899,1002820,822671,457080,82397,675323,813664,337690,593649,1012195,717432,523502,791605,1039846,722141,738902,415083,214806,504729,631950,337223,965598,1027820,912262,465051,251135,761973,718281,75552,794165,732157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]