SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540871 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540871 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360057,433594,902000,257498,363000,446499,513285,701928,970479,329066,936962,839030,130336,759319,12518,972911,184308,471487,807983,397754,494269,702081,851641,340628,185012,352729,72911,1026028,72313,667343,691941,343942,952211,671744,284364,905204,643622,167600,995607,1001079,933640,766718,583803,308531,303186,920879,939012,848065,94996,213303,546391,444736,725444,1014854,1018323,738152,269979,506607,359740,589727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001383s ]