SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392061 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392061 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438182,937972,750110,73822,455365,1014905,505773,488449,1943,857124,312678,992515,428119,735762,953660,353986,816731,227366,470669,241998,437361,298292,721399,608960,901423,25052,4740,43063,912455,119814,980776,456564,551237,12013,241535,741659,65066,359436,346477,1003037,141834,665627,918858,325411,237188,154570,108629,5664,460430,237892,505758,174097,988650,825124,499467,492487,401530,913391,831800,1034882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]