SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51043 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51043 [ RunTime:0.005160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441891,883259,1023239,668171,917814,462385,897859,183448,178728,403154,1045884,382157,750802,466366,17919,530056,775689,315232,658640,852938,472046,141276,482744,564682,554793,467909,177338,834612,398560,640010,618215,174100,417382,680247,765702,604196,383601,198489,581067,145263,700118,553551,569428,897297,722915,709604,855840,647395,241153,50765,387361,910926,286006,955505,740181,602118,721773,925693,321922,634616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006314s ]