SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022522 LIMIT 1 [ RunTime:0.004195s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022522 [ RunTime:0.005666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902747,54234,817646,164454,546128,753264,936758,1002675,904172,183218,911535,1039958,164620,348672,246914,491261,316910,629041,495217,169889,100715,975090,697403,636456,1018863,610155,218660,406325,232171,603984,675110,410186,636535,717967,655719,736656,168819,819725,157579,951186,631597,290442,113006,613896,836505,484778,888264,618449,825599,320302,399905,304452,617510,732234,64879,638120,659316,354346,368405,848141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001849s ]