SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317069 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317069 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108277,37244,568682,109325,278199,805680,1000948,258327,538900,221271,197911,343421,711194,199630,464259,854315,95973,29970,1040740,775824,691458,189997,79532,605660,211431,248896,353468,172147,34504,252640,699687,330595,943356,751576,138514,962600,245183,131684,76294,1009794,274907,796777,500952,1021473,893201,732815,490842,921221,672834,472814,40162,186014,933325,847217,128229,1025232,98258,258848,615385,482840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]