SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532843 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532843 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207811,701100,841707,805628,455278,1033883,876132,78285,830494,473567,110257,277516,54608,821631,685561,456992,629237,1017688,129017,697016,689909,1016215,176348,718738,294476,566673,233906,672121,553917,12544,882750,127540,48237,47393,390809,158265,240700,419614,505583,377817,166133,276774,170170,817575,640913,790794,261530,414530,543420,631253,702605,994495,1000452,449758,441390,950925,539756,667785,802516,1007251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]