SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544582 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544582 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567124,826998,848806,107424,677202,1026494,739073,859512,321765,796077,707801,785147,248470,300148,791490,91791,162064,548552,64091,121271,352102,358084,85315,731007,951568,151973,113817,342536,779220,428762,258309,330229,450491,613381,912846,844846,622922,950632,1008570,485235,31039,776284,671826,10011,39663,704021,705804,959277,80047,163497,973601,581487,915386,904431,94624,713301,271540,800963,903845,904595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]