SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116246 LIMIT 1 [ RunTime:0.001035s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116246 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232784,1028059,800167,756677,193212,562905,303075,336178,95312,414727,590148,596392,378258,899061,523749,109490,798020,845716,941766,770397,364099,475428,106080,534572,27399,636546,1016210,438438,743799,40167,741501,656680,798129,1014951,922944,474060,956143,661388,306699,955408,544719,47473,273061,369518,503282,985504,744261,808382,962895,260837,461078,811868,245780,426966,755806,394489,538243,172246,888736,843674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]