SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014671 LIMIT 1 [ RunTime:0.002564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014671 [ RunTime:0.007564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696893,358275,1034701,74950,603116,691180,883667,577833,356657,841622,666921,146758,94702,755298,426590,473098,888604,546066,913695,938115,94202,880984,877983,1031232,226233,598299,687687,212263,1047318,262031,887471,534091,93564,705561,976227,131628,782164,443322,522103,667665,287786,60452,399265,114651,344125,281745,97337,337539,940711,685100,131760,484669,308853,748685,1039608,19719,805358,881234,838955,930808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]