SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 279010 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 279010 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326125,1006179,917238,139539,321167,25048,742207,689013,595132,131009,789795,70036,1010436,429112,595190,233490,842065,443361,1024609,556218,394001,607763,179377,835169,220772,991916,848879,993604,323105,908791,379850,354579,272005,483571,79022,439024,818945,889774,617400,353576,116383,311675,277088,523235,307518,810268,213644,759529,223402,1012074,482800,200736,395101,966088,655447,634384,1042397,447554,329079,765833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 279010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 279010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]