SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504898 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504898 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532045,688778,124211,384739,449195,586017,770613,278608,98534,974060,292291,217786,632948,7035,946459,637376,599222,271556,663776,779767,544461,41013,677884,255436,978110,672487,36428,126529,311088,596689,539710,155872,990064,231305,912952,242679,634404,983818,581245,200660,512915,416351,510690,225767,999353,877696,1039993,478736,753190,148610,382731,767547,566965,423987,526557,61945,1042594,612067,117272,57310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]