SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547089 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547089 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188569,1034813,780520,656782,448805,327540,1003450,721605,959803,932902,707578,197686,139453,823974,688171,280389,339649,211463,913724,365110,1001048,667171,440255,205519,349337,172457,588964,120200,408637,597427,325249,439533,218174,249388,278331,457918,968816,1020291,605718,153325,774759,652973,522496,70300,167410,988813,26055,743084,1015116,263395,666449,912269,835265,598599,651313,827579,49615,975955,373885,140486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001397s ]