SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043881 LIMIT 1 [ RunTime:0.001063s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043881 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525933,943597,787601,323059,195021,379277,71968,987715,810055,679005,852366,1037943,421091,774119,750643,220399,127861,546794,322757,40158,658681,169014,848412,256798,477862,719259,914399,439447,599483,739528,213082,587912,716604,61779,174651,365861,808453,869468,800325,646980,44369,247632,677363,579194,169085,112302,195385,881906,372871,729272,25276,355757,200673,828122,358928,380277,635291,570488,361409,593511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.034715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002334s ]