SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302940 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302940 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517804,228551,875661,651706,924712,817833,1020571,366967,597830,706699,917840,935210,619753,430222,669708,313975,114116,250353,862384,590568,369202,996199,966134,797647,923281,216626,868244,535377,77028,697911,590999,148586,542188,292873,237438,695498,184035,355249,567120,467090,668022,409098,32736,35301,646538,58698,613524,138057,120773,626763,467208,954096,100873,495485,929908,871719,562393,486131,7826,699384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]