SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563980 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563980 [ RunTime:0.003312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592932,446839,974472,338823,62582,238531,277976,101844,707759,386095,809751,532715,364715,876307,385265,641625,993621,44678,835855,196893,46984,326924,360975,636549,772577,58076,579701,828285,1012427,250869,235433,64030,721060,7925,759735,419170,747628,942881,367646,940202,693069,321484,442423,411125,1022583,989209,554878,841137,351907,206438,171645,58014,969292,1011267,1001129,985558,708163,976076,267987,1015100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]