SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419280 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419280 [ RunTime:0.002406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249242,927039,30907,358368,302312,158039,525220,340401,100319,904728,571406,113628,536528,757832,854734,791486,373227,952351,1045129,689381,535993,208585,562759,98177,205715,50244,440022,8219,634726,50228,5495,808321,102336,492127,3425,1009401,100062,173630,654932,162684,411492,90465,93353,233603,651716,1023662,720574,374846,634498,391487,931554,10572,323260,282319,416108,853341,149142,811774,72192,682129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]