SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554223 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554223 [ RunTime:0.003756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26288,955434,806924,257914,595727,402817,387463,729503,78913,103779,881203,368200,729110,507476,277460,476435,864336,938205,680626,42330,747416,1023178,1005791,548857,807535,16826,826861,965896,565020,614062,721311,230398,285738,219026,812401,191322,208770,228637,147964,768604,914326,112686,784106,115576,94009,790590,1018934,693738,259368,165031,922190,141651,668197,143534,838476,780548,956004,715284,812827,487911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]