SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569694 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569694 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298967,419863,182630,879017,343074,1022837,528970,713919,9516,258190,961704,696036,23769,757821,485648,335116,602679,445843,702483,159776,584999,122834,21284,956656,14054,637126,51806,978295,310081,264854,82037,701872,454900,648169,369562,137487,476401,133268,787515,754827,968023,573595,320715,947975,1034631,129073,967527,375212,630139,982510,495315,641535,770585,492235,275412,681746,170975,807774,732391,801433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]