SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465076 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465076 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002951,553871,958918,490006,693123,586697,327091,891538,596579,368103,415914,297481,706412,361221,135874,754413,328042,663657,214732,955070,547308,824292,803223,390270,570122,791934,266001,779476,705742,472168,787251,267724,1015669,848661,924846,650638,323327,591091,967703,586040,421533,129588,342614,87689,845123,594648,868411,382815,720571,126960,932332,366005,807975,165745,782305,717916,98305,989659,684442,998881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]