SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042607 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042607 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473389,814349,433572,112094,742877,590641,29841,736844,623593,289221,52195,354792,832689,919713,291263,981826,631973,190138,238965,158399,668746,925528,544635,929030,431786,189492,451327,761891,1019855,847569,393233,369623,803423,361117,509978,426313,579927,552332,913529,300497,440392,956451,687142,305980,432572,389088,266750,388381,880755,932057,1025587,629503,951077,1041632,453699,645190,707382,803936,339729,144951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]