SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105041 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105041 [ RunTime:0.002889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930612,914740,758860,858614,99416,446504,926048,286526,203799,76080,848390,532148,271198,586304,231765,227084,840902,964405,941076,758402,917137,12493,674599,536019,36289,777401,947336,431295,260757,196224,878904,429478,789447,1036611,101803,400582,650065,1001110,258026,29831,468599,721259,754637,27911,259103,13105,1019040,114020,910513,105438,409063,596939,698790,224805,474655,121786,825196,388006,951502,868301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]