SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528720 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528720 [ RunTime:0.002330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497567,49721,331426,258804,371398,790968,2741,330438,294432,91109,811510,236708,142922,489413,897061,329461,918158,407015,237057,799759,897370,648232,1025394,691553,735607,526343,403329,812549,219043,779569,989792,20976,218443,292168,786516,756507,57345,818344,112162,832745,620179,1024778,456242,821962,732933,196740,715969,670652,550465,691019,13100,662740,394206,159231,1040352,681019,946410,791797,758326,432627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]