SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331880 LIMIT 1 [ RunTime:0.001116s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331880 [ RunTime:0.008288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944982,217119,368421,858674,968591,618661,752956,750048,13621,902805,802466,282296,167503,265300,642449,1042889,737201,860193,369350,358268,319260,74031,935419,71181,133243,921160,902463,955889,247077,1040787,322462,740440,991543,562218,983404,888678,906404,449115,829660,917330,650937,362012,937251,696804,913258,484582,427020,1037695,470811,84831,344620,211922,816585,1017205,145809,666228,736299,111531,664231,748092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000817s ]