SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410711 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410711 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61897,843521,606272,170894,454101,163750,738491,817911,717822,706397,269265,286336,288932,292656,775783,362803,334531,470889,557381,369388,549815,173267,684393,904574,502971,228686,900737,786605,940544,777442,810401,14072,663527,445032,612126,567409,200246,976913,912367,1023608,561879,520684,722868,831020,387399,402654,202985,749022,331363,1028565,178907,498884,1016878,542721,757372,215443,995038,183234,16867,46277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001451s ]