SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388198 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388198 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388248,591971,222507,159543,432619,1006166,663764,434418,35054,515996,60311,87271,545527,658161,873109,885437,940043,351887,814329,665158,539110,657109,607601,595012,475308,786283,14738,474781,768235,969110,991765,64640,863653,440969,816942,387118,449723,478815,942068,683243,167314,947411,873990,479701,257529,711170,59442,947224,987467,64962,72362,149790,307357,165220,1029016,985916,934237,591040,61247,974583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003187s ]