SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415851 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415851 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581984,588863,41516,1008244,844389,616207,724694,125449,122477,154309,141752,613064,804507,420566,652889,77627,339959,1017890,379219,805186,622296,2587,107454,51277,665472,210300,598599,130812,378142,652502,206976,414996,475374,830000,855884,113983,337454,481061,796975,23539,358880,351553,900363,441582,644789,957410,775662,76457,890967,1041598,219332,875786,10885,65733,225584,938165,910257,570495,724971,198036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]