SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50171 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50171 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634858,918480,996844,292642,341556,947589,117527,415599,814437,393043,972234,414428,657487,776908,979801,229172,121325,1019679,131976,13118,1011675,376857,255141,587620,644922,877721,427861,235653,19697,110351,437621,941324,177174,466531,164670,877442,206957,824684,88101,354647,79401,123965,284315,502119,440323,582357,848146,410201,62188,53037,904135,899944,80746,276381,755786,907593,1017460,3171,629915,818486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]