SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243178 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243178 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254871,840090,218036,385283,935410,1039881,70690,235235,83082,827812,486540,945307,145743,721117,940649,738536,903412,80559,116403,994778,95823,376552,944790,431514,712766,14059,642601,115346,412580,750261,74589,808523,720006,854653,410463,150279,227203,538270,307574,319374,232384,40710,890130,935951,940520,275084,786076,355999,842671,605324,961826,700852,232223,865076,357773,635457,981393,313247,1960,519426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]