SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404911 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404911 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168291,862583,843226,174097,379571,617880,1024435,561592,219336,554641,744941,403894,883388,670853,492434,864008,464531,71406,130375,901685,275490,893016,694735,338065,1008340,545743,255060,221152,770952,441644,322435,637936,245998,631312,183752,475279,909311,606826,587672,170761,956835,129818,259563,651496,112800,709064,994661,952104,510114,868230,907676,501552,158884,845297,444380,977980,1032613,433101,123266,185874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]