SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316140 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316140 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468765,110498,1039574,424451,685216,331163,467793,670136,741281,806333,673919,770720,938064,774200,425198,1028452,45199,119499,827305,477108,979311,539883,931080,145727,722266,27073,95195,380558,832231,654885,122649,944497,1039639,338701,995350,863504,471994,375010,152162,337131,556585,565416,620376,964928,866134,416442,814368,769516,296022,811451,472438,845244,223443,685877,873654,155199,318981,148845,650715,956929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]