SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500510 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500510 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554185,722501,934388,1037699,110321,116445,880645,449171,40629,607648,319339,480309,779615,511840,253948,637758,290201,316637,965335,589477,672868,364647,746250,409908,242183,353384,386806,272316,726129,421558,846318,12857,65882,292474,549794,67051,953052,379840,843289,25202,927902,532860,701324,1018299,1014824,224397,341775,580040,448628,274349,196314,90230,496003,976392,487714,712336,481690,583406,554849,746559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]