SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438118 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438118 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173340,645623,748771,733692,1002395,175337,742803,944536,618521,6717,125263,653294,553487,91461,312668,1036594,260012,290865,320885,94754,569705,1013285,471862,964052,649676,655890,23787,1004400,432,913619,698200,115626,593870,485824,18172,419555,1021584,956926,365036,724131,757338,653918,417463,740726,348155,609153,72578,241616,765245,1009744,966016,467633,577914,1018369,805649,428699,556460,537681,139668,225954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]