SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464511 LIMIT 1 [ RunTime:0.003607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464511 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704602,453707,175658,252191,527721,305405,95671,1045302,817995,608120,734898,749216,1034163,858964,318724,252705,784789,510882,200133,595313,928191,210799,61339,970977,565286,364415,484232,964774,751814,96675,606036,223427,540992,920822,416428,23723,31238,505966,499715,661514,133287,634715,1044501,225770,880440,329397,861386,984447,278966,728892,86948,358775,781537,686349,915122,172035,744686,279645,527305,759178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001774s ]